[dbo].[AccountPending]

Property	Value
Heap
Row Count	2
Created	10:31:12 AM Tuesday, March 02, 2010
Last Modified	11:39:59 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Identity
	AccountPendingID	int	4	1 - 1
	Username	varchar(60)	60
	Password	varchar(32)	32
	Prefix	varchar(25)	25
	FirstName	varchar(20)	20
	MiddleName	varchar(20)	20
$Indexes iWC: LastName\Email$	LastName	varchar(30)	30
	Suffix	varchar(10)	10
	Designation	varchar(32)	32
	Informal	varchar(20)	20
	Title	varchar(80)	80
	Organization	varchar(80)	80
	Address1	varchar(40)	40
	Address2	varchar(40)	40
	Address3	varchar(40)	40
	County	varchar(25)	25
	City	varchar(40)	40
	StateProvince	varchar(15)	15
	PostalCode	varchar(10)	10
	Country	varchar(25)	25
	AddressPurpose	varchar(20)	20
$Indexes iWC: LastName\Email$	Email	varchar(100)	100
	Website	varchar(255)	255
	WorkPhone	varchar(25)	25
	HomePhone	varchar(25)	25
	TollFree	varchar(25)	25
	Fax	varchar(25)	25
	BirthDate	datetime	8
	Gender	varchar(8)	8
	SICCode	varchar(10)	10
	ExcludeDirectory	bit	1
	ExcludeMail	bit	1
	RecordAdded	int	4
	UserDefinedField	text	max
	MemberType	varchar(5)	5

Name	Columns
iWC	LastName, Email

SQL Script

CREATE TABLE [dbo].[AccountPending]
(
[AccountPendingID] [int] NOT NULL IDENTITY(1, 1),
[Username] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Password] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Prefix] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FirstName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MiddleName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Suffix] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Designation] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Informal] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Title] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Organization] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Address1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Address2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Address3] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[County] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[City] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[StateProvince] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PostalCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Country] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AddressPurpose] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Email] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Website] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WorkPhone] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HomePhone] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TollFree] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Fax] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BirthDate] [datetime] NULL,
[Gender] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SICCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExcludeDirectory] [bit] NULL,
[ExcludeMail] [bit] NULL,
[RecordAdded] [int] NOT NULL,
[UserDefinedField] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MemberType] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iWC] ON [dbo].[AccountPending] ([LastName], [Email]) ON [PRIMARY]
GO